package com.database;

public class DATABASEDEMO {


	//	public static final String TABLE = "zigbee";
	//	public static final String _ID = "_id";
	//	public static final String FUNKTION_NAME = "zigbee_function_name";
	//	public static final String ROOM_NAME = "zigbee_room_name";
	//	public static final String NAME = "zigbee_name";
	//	public static final String STATUS = "zigbee_status";
	//	public static final int STAUS_INLINE = 0;
	//	public static final int STATUS_OFFLINE = 1;
	//	public static final String SCENE_NAME = "zigbee_scene_name";
	//	public static final String IS_SEND_STATE = "zigbee_issendstate";
	//	public static final int IS_SEND_STATE_YES = 0;
	//	public static final int IS_SEND_STATE_NO  = 1;
	//	public static final String IS_ALARM = "zigbee_isalarm";
	//	public static final int IS_ALARM_YES = 0;
	//	public static final int IS_ALARM_NO = 1;
	//	public static final String IS_OPEN = "zigbee_isopen";
	//	public static final int IS_OPEN_YES = 0;
	//	public static final int IS_OPEN_NO  = 1;
	//	public static final String MAC_0 = "mac0";
	//	public static final String MAC_1 = "mac1";
	//	public static final String SIGNAL = "zigbee_signal";
	//	public static final String HEART_BEAT = "zigbee_heartbeat";
	//	public static final String POWER = "zigbee_power";
	//	
	//	public static final String ZIGBEE_TABLE = "CREATE TABLE " + TABLE + " ( "
	//				+ _ID + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
	//				+ FUNKTION_NAME + " TEXT ,"
	//				+ ROOM_NAME + "TEXT  ,"
	//				+ NAME + " TEXT ,"
	//				+ STATUS + " INTEGER ,"
	//				+ SCENE_NAME + " TEXT ,"
	//				+ IS_SEND_STATE + " INTEGER ,"
	//				+ IS_ALARM + " INTEGER ,"
	//				+ IS_OPEN + " INTEGER ,"
	//				+ MAC_0 + " TEXT ,"
	//				+ MAC_1 + " TEXT ,"
	//				+ SIGNAL + " TEXT ,"
	//				+ HEART_BEAT + " TEXT ,"
	//				+ POWER + " TEXT "
	//				+" ); ";
	//	

	//	public static final String TABLE = "function";
	//	public static final String _ID = "_id";
	//	public static final String NUMBER = "function_nubmer";
	//	public static final String NAME = "function_name";
	//
	//	public static final String CREATE_TABLE = "CREATE TABLE " + TABLE + " ( "
	//			+ _ID + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
	//			+ NUMBER + " TEXT NOT NULL ,"
	//			+ NAME + " TEXT NOT NULL"
	//			+" );";	

	//	public static final String TABLE = "roomtype";
	//	public static final String _ID   = "_id";
	//	public static final String NUMBER = "room_number";
	//	public static final String NAME = "room_name";
	//
	//	public static final String CREATE_TABLE = "CREATE TABLE " + TABLE + " ( "
	//			+ _ID + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
	//			+ NUMBER + " TEXT NOT NULL ,"
	//			+ NAME + "TEXT NOT NULL"
	//			+" );";

//	public static final String TABLE = "scene";
//	public static final String _ID = "_id";
//	public static final String NUMBER = "scene_number";
//	public static final String NAME = "scene_name";
//
//	public static final String CREATE_TABLE = "CREATE TABLE " + TABLE + " ( "
//			+ _ID + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
//			+ NUMBER + " TEXT NOT NULL ,"
//			+ NAME + "TEXT NOT NULL"
//			+" );";

//	public static final String TABLE = "phone";
//	public static final String _ID = "_id";
//	public static final String NUMBER = "phone_number";
//	public static final String IS_RECEIVE = "phone_isreceive";
//	public static final int IS_RECEIVE_YES = 0;
//	public static final int IS_RECEIVE_NO  = 1;
//	public static final String MAINCOMMUNITY = "phone_maincommunity";
//	public static final int MAINCOMMUNITY_YES = 0;
//	public static final int MAINCOMMUNITY_NO  = 1;
//	public static final String MAINSECURITY = "phone_mainsecurity";
//	public static final int MAINSECURITY_YES = 0;
//	public static final int MAINSECURITY_NO  = 1;
//	
//	
//	public static final String CREATE_TABLE = "CREATE TABLE " + TABLE + " ( "
//			+ _ID + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
//			+ NUMBER + " TEXT NOT NULL ,"
//			+ IS_RECEIVE + " INTEGER,"
//			+ MAINCOMMUNITY + " INTEGER,"
//			+ MAINSECURITY + " INTEGER"
//			+" );";
	

//	public static final String TABLE = "zigbee";
//	public static final String _ID = "_id";
//	public static final String FUNKTION_NAME = "zigbee_function_name";
//	public static final String ROOM_NAME = "zigbee_room_name";
//	public static final String NAME = "zigbee_name";
//	public static final String STATUS = "zigbee_status";
//	public static final int STAUS_INLINE = 0;
//	public static final int STATUS_OFFLINE = 1;
//	public static final String SCENE_NAME = "zigbee_scene_name";
//	public static final String IS_SEND_STATE = "zigbee_issendstate";
//	public static final int IS_SEND_STATE_YES = 0;
//	public static final int IS_SEND_STATE_NO  = 1;
//	public static final String IS_ALARM = "zigbee_isalarm";
//	public static final int IS_ALARM_YES = 0;
//	public static final int IS_ALARM_NO = 1;
//	public static final String IS_OPEN = "zigbee_isopen";
//	public static final int IS_OPEN_YES = 0;
//	public static final int IS_OPEN_NO  = 1;
//	public static final String MAC_0 = "mac0";
//	public static final String MAC_1 = "mac1";
//	public static final String SIGNAL = "zigbee_signal";
//	public static final String HEART_BEAT = "zigbee_heartbeat";
//	public static final String POWER = "zigbee_power";
//
//	public static final String CREATE_TABLE = "CREATE TABLE " + TABLE + " ( "
//			+ _ID + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
//			+ FUNKTION_NAME + " TEXT ,"
//			+ ROOM_NAME + "TEXT  ,"
//			+ NAME + " TEXT ,"
//			+ STATUS + " INTEGER ,"
//			+ SCENE_NAME + " TEXT ,"
//			+ IS_SEND_STATE + " INTEGER ,"
//			+ IS_ALARM + " INTEGER ,"
//			+ IS_OPEN + " INTEGER ,"
//			+ MAC_0 + " TEXT ,"
//			+ MAC_1 + " TEXT ,"
//			+ SIGNAL + " TEXT ,"
//			+ HEART_BEAT + " TEXT ,"
//			+ POWER + " TEXT "
//			+" ); ";
	
	
	public static final String TABLE = "scene";
	public static final String _ID = "_id";
	public static final String NUMBER = "scene_number";
	public static final String NAME = "scene_name";
	
	public static final String CREATE_TABLE = "CREATE TABLE " + TABLE + " ( "
			+ _ID + " INTEGER PRIMARY KEY AUTOINCREMENT ,"
			+ NUMBER + " TEXT ,"
			+ NAME + "TEXT "
			+" );";
	
	public static void main(String[] args) {

		System.out.println(CREATE_TABLE);
	}

}
